﻿CREATE TABLE [dbo].[Product_log] (
    [ProductNo]    VARCHAR (10)  NOT NULL,
    [ProductName]  VARCHAR (120) NOT NULL,
    [ShortName]    VARCHAR (30)  NULL,
    [ProductSpec]  VARCHAR (60)  NULL,
    [ProductModel] VARCHAR (60)  NULL,
    [ProdBarcode]  VARCHAR (30)  NULL,
    [ProdClass]    INT           NULL,
    [BaseUnit]     INT           NULL,
    [AidUnit]      INT           NULL,
    [BaseForAid]   INT           NULL,
    [Place]        VARCHAR (100) NULL,
    [Brand]        VARCHAR (100) NULL,
    [Bopomofo]     VARCHAR (30)  NULL,
    [Remark]       VARCHAR (100) NULL,
    [RecordID]     INT           NOT NULL,
    [UserID]       VARCHAR (60)  NOT NULL,
    [ModifyTime]   DATETIME      NOT NULL,
    [Action]       CHAR (1)      NOT NULL
);

